using System;
using System.Collections.Generic;
using System.Text;

using Schemata.Core;
using NUnit.Framework;

namespace Schemata.Core.Tests
{
    [TestFixture]
    public class CustomersFixture : NorthwindTableFixture
    {
        public static TableSchema CustomersTableSchema
        {
            get { return NorthwindDatabaseSchema.GetTableSchemaByName("Customers"); }
        }

        [Test]
        public void VerifyColumns()
        {
            Assert.IsNotNull(CustomersTableSchema);
            Assert.AreEqual(11, CustomersTableSchema.Columns.Count);
        }

        [Test]
        public void VerifyForeignKeys()
        {
            Assert.IsNotNull(CustomersTableSchema);
            Assert.AreEqual(2, CustomersTableSchema.ForeignKeys.Count);
        }
    }
}
